The following software updates are needed in SAS Risk and Finance Workbench to support the IFRS9 content release.

• Add checks for hierarchy node names to avoid exact duplicates, which results in a blank hierarchy.
• Add "Legal Entity Identifier" (LEI) column to uploaded hierarchies so that the produced XBRL includes the LEI.
• Allow sheets to have no rows of data and to load data for sheets that do have data.
• Load data in the proper order so that worksheets show data whether scenarios are on the X or Y axis.
• Ensure user ID/password usage in mid-tier and SAS session for authentication when executing code within a Script of a Model Group.
• Make Taxonomy Hierarchy category definitions function correctly in upgrade from SAS Risk and Finance Workbench 2.2 release to the 2.3 release.
• Ensure the path to the workgroup is created correctly when a workgroup is specified.
• Ensure that properties are updated appropriately when adding and modifying software components.
• Ensure that component properties are created and can be modified appropriately in metadata.
• Update values properly when overrides are applied to even and equal allocation methods so as to update subtotal and update child node cells in a worksheet.
• Ensure that filter values specified by users are honored in the _OG() macro.
• Update the allocation script so that the allocation rule is "Proportional or Even" instead of "Relative or Equal." The default is now Proportional.
• Improved log messaging if Taxomony tables are not set up correctly.
• Display validation error text when hovering over a cell if a validation error has occurred.
• Honor currencies as needed when previewing the landing area data, not just the current currency.
• Make drilldown in sample code consistent in Postgres and Oracle databases for zero-length strings.

Operating System and Release Information

A fix for this issue for Risk and Finance Workbench 2.3 is available at:

A fix for this issue for SAS Risk and Finance Workbench 2.3 is available at: